package com.globalwave.rule;

import java.util.List;

import com.globalwave.rule.entity.RuleLimit;


/**
 */
public class AccLimitJDBCDAO  {
    
    public AccLimitJDBCDAO() {
    }

    public List<RuleLimit> findByRuleId(String ruleId) throws Exception {

        StringBuffer sql = new StringBuffer() ;
        
        sql.append( " SELECT L.*, F.FACTOR_TYPE " );
        sql.append( "   FROM ACC_LIMIT L, ACC_FACTOR F" );
        sql.append( "  WHERE L.CAL_OBJECT_TYPE = 'R' " );
        sql.append( "    AND L.FACTOR_CD = F.FACTOR_CD " );
        sql.append( "    AND L.CAL_OBJECT_ID = ? " );
        sql.append( "  ORDER BY LIMIT_ID " );
        
        //CommonRecord params = new CommonRecord();
        //params.setValue("CAL_OBJECT_ID", ruleId) ;
        
        //RecordSet rs = fyDao.query(sql.toString(), params);
        
        //return rs ;
        return null ;
    }
    
}
